Vendor Aging balances are not matching with Vendor balances in Trail balance.

您所在的位置:网站首页 statement of account in Vendor Aging balances are not matching with Vendor balances in Trail balance.

Vendor Aging balances are not matching with Vendor balances in Trail balance.

2023-04-18 23:06| 来源: 网络整理| 查看: 265

Differences can arise in the reports  with closed dates of transactions and the reports may not necessarily match for that reason.

• Vendor Balance list records the balance as at a date.

• Vendor Ageing Report looks at what transactions  are OPEN at a date.

Through open transaction editing (normally) the date principle determines the date the transaction is settled (closed) and that this could be closed at a date prior to your balance date, and be settled against a payment past your balance date. Therefore it would be excluded from the Ageing Report, but not the balance list.

Dynamics AX is date driven system rather than by period buckets, that's how it works.  – when you set the date principle to the date on which you do the open transaction editing settlement (i.e. today's date), generally the results match. It is possible to get currency differences after exchange rate adjustment when the invoice stays open after financial closing and you are running a back dated report.

An example is  the year-end process when the Exchange adjustment process for Supplier, resulted in a few of transactions being created). The currency revaluations are posted  into the current year adjustments for invoices which were settled and  posted last year, but for which  the invoice was not closed prior to the revaluation (i..e. the order had been settled but was still open for revaluation). In  that case such a currency revaluation posting  affects only the aging analysis report. . It would not not affected Vendor balances / Statement of Account in the GL/AP module. If the system has posted settlements and the transactions are closed, then this cannot be rectified with data corrections,.  However to clarify such a situation e.g.  for audit purposes there is an exception report available which highlights such differences ; Name : “vendcheckSettlement”



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3